UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'awK9gecgBBsZIbdLO2gAOiVYdWEtcdIMSBC0FVkzbi0='
WHERE
key_id = '457f3e71a3207727f632f06ea994759281a90f2ce154b7f12e10e877fd60ccb8'
AND (
token = 'awK9gecgBBsZIbdLO2gAOiVYdWEtcdIMSBC0FVkzbi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)