UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZO/k7S8VTS1cYdGwsonQqOtjvdz3G2xCqLmuCHRRVg='
WHERE
key_id = '1e1764eb388536eb2be06f9dff648486cf1d6469dc39b3858c68e4e87102a0d1'
AND (
token = '0ZO/k7S8VTS1cYdGwsonQqOtjvdz3G2xCqLmuCHRRVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)