UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xv8nsgAZo2u5mFoy65rlYgPE3w8q67vthMNPa2Vsb8U='
WHERE
key_id = '82bce43910c3dc30df827438446ad07c1252b78ea5d38ef5ed0886042cd1f200'
AND (
token = 'Xv8nsgAZo2u5mFoy65rlYgPE3w8q67vthMNPa2Vsb8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)