UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5sXEfF0I3U+fVDWelnn3Mnqt/EGf/FNPgyI1RSt2dVE='
WHERE
key_id = '783b46ce2f2970cdcf82c4e3b5e8affd5b1d815e0682d42e46eb8801ab87517f'
AND (
token = '5sXEfF0I3U+fVDWelnn3Mnqt/EGf/FNPgyI1RSt2dVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)