UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6BBHbjJ9D7NTViyRurcF4ULmK7P8OhXuXkosVD61u1Q='
WHERE
key_id = '4dc7d6989b090e662175cd785d08bb805b383ab1f8ca18b5586fec3351719706'
AND (
token = '6BBHbjJ9D7NTViyRurcF4ULmK7P8OhXuXkosVD61u1Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)