UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pj8HOreOdjKb/9EmzIOx8fD+fInjdAVQnFHFe8DOJ5g='
WHERE
key_id = 'f40aa077f14217149f91a1a367a48a409e9fa7f5d6befbccab767eecc6dc9ecd'
AND (
token = 'Pj8HOreOdjKb/9EmzIOx8fD+fInjdAVQnFHFe8DOJ5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)