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