UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aFCKGSB3NZKY2TTiY5Tl7a6mx4x44yMoq3V1ntAiJLU='
WHERE
key_id = '592b7a6225a85083e31ea320f7277273e07e72c34a02b6fca791f317896f3414'
AND (
token = 'aFCKGSB3NZKY2TTiY5Tl7a6mx4x44yMoq3V1ntAiJLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)