UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iRQrNBTzRyclNKdy8N5xXKiou9UVZc2BWhN3ezc6sz0='
WHERE
key_id = '9e0f936c2cfff0a6b106593d6cdc22b7efffd4eb5ccf3d3149e277c0bf756634'
AND (
token = 'iRQrNBTzRyclNKdy8N5xXKiou9UVZc2BWhN3ezc6sz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)