UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oLcMMdjr6detkOLvd2o6j16Jg3AivhTU+HP8FIhbkIc='
WHERE
key_id = '8f9f72214b7d5cf37a0f0f75453ed214a5d8a1e7639be5adc090780f99a56ed9'
AND (
token = 'oLcMMdjr6detkOLvd2o6j16Jg3AivhTU+HP8FIhbkIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)