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