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