UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oXFi97AKquH+AWwLy6o2OgvAKRXm5r2gLoGip+uenvE='
WHERE
key_id = 'e9adfaa79ea09220bb27027db726f163b60604a2192d5d30ecf072d2f96f76e4'
AND (
token = 'oXFi97AKquH+AWwLy6o2OgvAKRXm5r2gLoGip+uenvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)