UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mSgBXinzBfTYU6CsTd3nkEfkzZteD+9OF4Q9KAElgR4='
WHERE
key_id = '9e911975859d01711186089a0fed406c29893e7b257a5e14ea8d73a72b521642'
AND (
token = 'mSgBXinzBfTYU6CsTd3nkEfkzZteD+9OF4Q9KAElgR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)