UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zVfYin3gEErRKYXA7sgNH+T3f8RUMu9YQRjdRWFq3eY='
WHERE
key_id = '3c93c1b14d588fd29e158619f79867c7b7704f46b2247abc421a6a1ff53ee500'
AND (
token = 'zVfYin3gEErRKYXA7sgNH+T3f8RUMu9YQRjdRWFq3eY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)