UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fDJZ7wrN+IJ5JVE8/zwofiPPjPdwtYsQZEZi7SYX7YY='
WHERE
key_id = 'a05730e5e01334f3b8c88cb08033c5dda0cbbfe402af9619388e733a2bede0da'
AND (
token = 'fDJZ7wrN+IJ5JVE8/zwofiPPjPdwtYsQZEZi7SYX7YY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)