UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cJaCTAVFAkh9TRKVlCLETuEQ9WPmL/v48Wr4+nsv+64='
WHERE
key_id = '2674540bea6cae0b1054ad9681d23cb4d1ff2171c755aeec5849359c446580de'
AND (
token = 'cJaCTAVFAkh9TRKVlCLETuEQ9WPmL/v48Wr4+nsv+64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)