UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNGdm6IHShqaJS68yAB60lFev5p1w9yJshZNSiKfU5k='
WHERE
key_id = '566b81328854f11d64effbf1010b0ed6370df3d8a93fcd375f0a2dc42387c56b'
AND (
token = 'zNGdm6IHShqaJS68yAB60lFev5p1w9yJshZNSiKfU5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)