UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AN907rLQz0pBs74teI6VEbxAnOAeUjHoBcAJu9sOahk='
WHERE
key_id = '0c4573d14a64f85e2afdf0331560cc213be36e67b45d25335650ee63dec8703f'
AND (
token = 'AN907rLQz0pBs74teI6VEbxAnOAeUjHoBcAJu9sOahk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)