UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JQwQDhT2PMp5dk0Xugy2dKx3bL7ebutX0mkd1kzywbc='
WHERE
key_id = 'a065d5f53f9b86995c61a312bb44d2669e3eb6bc669abecfd068df22ab2779bf'
AND (
token = 'JQwQDhT2PMp5dk0Xugy2dKx3bL7ebutX0mkd1kzywbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)