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