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