UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCNKWUBorfLPzv5Fb8jVn0GGsRrtTlCtq/N3w6rXxog='
WHERE
key_id = '8a63afeb5d2742f25fc89606e0a1c55d2a5e752fbdaf5ae3b2c66f3c3e308575'
AND (
token = 'zCNKWUBorfLPzv5Fb8jVn0GGsRrtTlCtq/N3w6rXxog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)