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