UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qW9sGNyc4H/ecFNnrj/BcNqZBEbq7jkQRGvVhOVyDDc='
WHERE
key_id = '7a4e4abac3c9fffc484f89d78435044c0a484818a84549aa2ef764785825e528'
AND (
token = 'qW9sGNyc4H/ecFNnrj/BcNqZBEbq7jkQRGvVhOVyDDc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)