UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dkvGEXnCyKdmQ8t53mJ1b8LI0QnH5MHzMV9v8zrFYk='
WHERE
key_id = 'b5c45f8a3a41e59ab829f6904ff3828f253c983dcdbcf293f9092ec5090f43d1'
AND (
token = '7dkvGEXnCyKdmQ8t53mJ1b8LI0QnH5MHzMV9v8zrFYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)