UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l5JwVDru1zwZHCqQ3q5ilJvPzSHBlyT4NaaBIIJx6t8='
WHERE
key_id = 'c86be2d88f6cff64bfc904b376daca7ca7089d24d29570e25f1da7e4ce11c3a5'
AND (
token = 'l5JwVDru1zwZHCqQ3q5ilJvPzSHBlyT4NaaBIIJx6t8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)