UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gNwBMxJq3crJDQOOtFWlF9MxEF6nbPRkEK/gK2/tXg8='
WHERE
key_id = '175fa00f42cea838c27ef5768a9ca9d80baf85713e7645fabd26163d5b87eef0'
AND (
token = 'gNwBMxJq3crJDQOOtFWlF9MxEF6nbPRkEK/gK2/tXg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)