UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oBVm1s5ijUCcr/yPp4R4lSBnJ3iZgtMKvgAq1gD3C9o='
WHERE
key_id = 'e7f3598dc93006dfda5a01bba42b57811323a61986fe28c8d0b6814622d64dbb'
AND (
token = 'oBVm1s5ijUCcr/yPp4R4lSBnJ3iZgtMKvgAq1gD3C9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)