UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E8i071S3hd+K2VW/dSqBH5jRnZS/jTx6NQCCLVjDolA='
WHERE
key_id = '3ef4f5e7bbd0bdc1aae654873a614f088b592a69e490c211ea9433e1d0f67f07'
AND (
token = 'E8i071S3hd+K2VW/dSqBH5jRnZS/jTx6NQCCLVjDolA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)