UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hWpBTBQIXYSr3ayU5DQm+BgF7EzisBMq5gwgHog0kiI='
WHERE
key_id = '1a56ead3e4ce10435a73996ead8d4f5af377fe37c464c547cba48aa5b891a7be'
AND (
token = 'hWpBTBQIXYSr3ayU5DQm+BgF7EzisBMq5gwgHog0kiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)