UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9spINb+okBzingWDPBgda8DYw1wudz0f3fv357uBWRk='
WHERE
key_id = 'd46769b6ab0576948fdc0247ff7147fbc1c99dc191e72bb1647a514546a7a007'
AND (
token = '9spINb+okBzingWDPBgda8DYw1wudz0f3fv357uBWRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)