UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yGxLui0s9qnQOHAAtTeXcNNSPSJd+vQI+Y7T+VLwDVU='
WHERE
key_id = '5fae2b8ea5520668ae9397ba677ae71f74b163280f4b8d087f98b77eec3ff6fc'
AND (
token = 'yGxLui0s9qnQOHAAtTeXcNNSPSJd+vQI+Y7T+VLwDVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)