UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ROwkdm+htCTwMfCfywKFORfQgUZWciy5nx4OSl6Jcbg='
WHERE
key_id = 'ec25255fe67a0080492646f58be10d02346ec019c2315266e832f2711073869e'
AND (
token = 'ROwkdm+htCTwMfCfywKFORfQgUZWciy5nx4OSl6Jcbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)