UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Rmrf8kHa5P1/i8BK3W8wUj5wlO2liBTqt256ZwYdYg='
WHERE
key_id = 'e5e3ae38b7cc43e9673bdc403328d6025644f6e10b10b892edc85d78a462af8e'
AND (
token = '9Rmrf8kHa5P1/i8BK3W8wUj5wlO2liBTqt256ZwYdYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)