UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jCoccigBpTwbTslo/zCPTcZuCY9E9paHtavroFYgotg='
WHERE
key_id = 'bac8ce2ec54933389126daf1fc214bc7b80dd7f490533c1c391d04fd79d13571'
AND (
token = 'jCoccigBpTwbTslo/zCPTcZuCY9E9paHtavroFYgotg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)