UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPk4b1e9Yu9w0FyI+rK6pPj+HVJJ0bN0uZh9JjXnx4I='
WHERE
key_id = 'ee9784e0813034057b2f0f755a419b21e3002198b27dc8d999ad9f0c3a2929ce'
AND (
token = 'sPk4b1e9Yu9w0FyI+rK6pPj+HVJJ0bN0uZh9JjXnx4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)