UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XoEgVLohzn7iZJ6sRKLT2Wys73E5QttFKUewU/nW0Kk='
WHERE
key_id = '7e01dba5f1607559d0795f7d3d11d8d2b6cc42fc675aed28c2e81670a8df2749'
AND (
token = 'XoEgVLohzn7iZJ6sRKLT2Wys73E5QttFKUewU/nW0Kk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)