UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VFSR6wCAKc3FKCTPLCHNY757hsjE6DSE7BaVWyw+ahc='
WHERE
key_id = 'ad5d2aafea8fa8f28c2deba2468a79755af4600cb9674dd2ea160cdef781a2e7'
AND (
token = 'VFSR6wCAKc3FKCTPLCHNY757hsjE6DSE7BaVWyw+ahc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)