UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'spa1Xyu3Kthcb0Hz228Y0t0jH5m5qfjs2wnQW28UeeE='
WHERE
key_id = 'e9887c5db3c4986fe229e369665548139e136d7e03606c6360c6305503b85fe6'
AND (
token = 'spa1Xyu3Kthcb0Hz228Y0t0jH5m5qfjs2wnQW28UeeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)